Error: #NUM! displays due to problem with numbers in formula.

Error:

#NUM!

Cause:

The formula has a problem with numbers. For example, the formula contains the wrong type of numeric argument, or the formula returns a number that is too large or too small to be represented in the worksheet.

Solution:

Select the arguments used in the formula for acceptable values, or change the formula so that the calculated result is within the allowable number range (-9.999999999999e-307 : 9.9999999999999e+307).